How to: Repeat character string within a cell.
Solution:
Use the REPT() function.
1) Select the cell where the repeated character string should appear.
2) Type an equal sign and the REPT Command:
=REPT()
3) Within the parentheses of the command, type the text to repeat (in double quotes), a comma, and the number of times the text should be repeated.
EXAMPLE: =REPT(<double quotes>*<double quotes>,50)
NOTE: No spaces are allowed within the function. The result of the REPT function cannot be longer than 255 characters.
